Service Director Tables
tblSvActivityStatus -- SV Activity Status table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | tinyint | 1 | |||
Description | pDescription | 255 | |||
ActivityDispatchStatus | tinyint | 1 | 0 = Open, 1 = Completed, 2 = Billed, 3 = Posted, 4 = NA | ||
Action | tinyint | 1 | 0 = None, 1 = System, 2 = Hold, 3 = Release, 4 = Cancel, 5 = Reopen, 6 = Complete | ||
Sequence | tinyint | 1 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvAttachmentLocal -- SV Local Attachment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
AttachmentId | int | 4 | |||
EntryDate | datetime | 8 | |||
Keywords | nvarchar | 255 | |||
Comment | nvarchar | max | |||
DocumentName | nvarchar | 255 | |||
Document | varbinary | max | |||
TechID | bigint | 8 | |||
HostID | nvarchar | 20 | |||
SynchID | bigint | 8 | |||
Synched | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvBillingType -- SV Billing Type table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BillingType | nvarchar | 10 | |||
Description | pDescription | 255 | |||
BillableYN | bit | 1 | -1 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvEquipment -- SV Equipment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
GeneralEquipmentID | bigint | 8 | |||
EquipmentNo | nvarchar | 24 | |||
Description | pDescription | 255 | |||
ItemID | pItemID | 24 | |||
SerialNumber | pSerNum | 35 | |||
TagNumber | nvarchar | 255 | |||
SiteYN | bit | 1 | 0 | ||
CustID | pCustID | 10 | |||
SiteID | pLocID | 10 | |||
Manufacturer | pDescription | 255 | |||
Model | pDescription | 255 | |||
CategoryID | nvarchar | 12 | |||
Status | tinyint | 1 | 0 | Equipment Status | 0 = Active, 1 = Inactive, 2 = Deleted |
Usage | tinyint | 1 | 0 | Equipment Usage | 0 = All, 1 = Customer, 2 = Company |
ServiceContractCharge | pDecimal | 13 | 0 | ||
Ownership | tinyint | 1 | 0 | Equipment Ownership | 0 = None, 1 = Customer, 2 = Company |
AssetID | pAssetID | 15 | |||
GLAcctExpense | pGlAcct | 255 | |||
AdditionalDescription | nvarchar | max | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvEquipmentActivity -- SV Equipment Activity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
EquipmentID | bigint | 8 | |||
Type | tinyint | 1 | Equipment Activity Type | 0 = Purchase, 1 = Sale, 2 = Transfer | |
Description | pDescription | 255 | |||
ContactID | nvarchar | 10 | |||
SiteID | pLocID | 10 | |||
ContactName | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
OrderDate | datetime | 8 | |||
ShipDate | datetime | 8 | |||
InvoiceDate | datetime | 8 | |||
OrderNumber | nvarchar | 25 | |||
InvoiceNumber | pInvoiceNum | 15 | |||
Price | pDecimal | 28,10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvEquipmentCategory -- SV Equipment Category table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
CategoryID | nvarchar | 12 | |||
Description | pDescription | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvEquipmentKnowledgebase -- SV Equipment Knowledgebase table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
EquipmentID | bigint | 8 | |||
Description | pDescription | 255 | |||
AdditionalDescription | nvarchar | max | |||
Resolution | nvarchar | max | |||
EntryDate | datetime | 8 | |||
EnteredBy | pUserID | 20 | |||
WorkOrderNo | pTransID | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvEquipmentParts -- SV Equipment Parts table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
EquipmentID | bigint | 8 | |||
PartNo | nvarchar | 24 | |||
ItemID | pItemID | 24 | |||
Description | pDescription | 255 | |||
Qty | pDecimal | 28,10 | |||
EstimatedCost | pDecimal | 28,10 | |||
PreferredVendor | pDescription | 255 | |||
LeadTime | pDecimal | 28,10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvEquipmentService -- SV Equipment Service table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
EquipmentID | bigint | 8 | |||
WorkToDoID | nvarchar | 10 | |||
ScheduleType | tinyint | 1 | 0 | Schedule Type | 0 = Year, 1 = Month, 2 = Day |
ScheduleInterval | tinyint | 1 | 0 | ||
ScheduleAutoPrompt | tinyint | 1 | 0 | ||
ScheduleStartDate | datetime | 8 | |||
ScheduleEndDate | datetime | 8 | |||
ScheduleNextDate | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvEquipmentWarranty -- SV Equipment Warranty table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
EquipmentID | bigint | 8 | |||
CoverageType | tinyint | 1 | 0 | Coverage Type | 0 = None, 1 = Labor / Parts, 2 = Labor, 3 = Parts |
IntervalType | tinyint | 1 | 0 | Interval Type | 0 = Year, 1 = Month, 2 = Day |
Interval | tinyint | 1 | 0 | ||
StartDate | datetime | 8 | |||
EndDate | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvHistoryWorkOrder -- SV Work Order History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
PostRun | pPostRun | 14 | |||
WorkOrderNo | pTransID | 8 | |||
OrderDate | datetime | 8 | |||
CustID | pCustID | 10 | |||
SiteID | pLocID | 10 | |||
Attention | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
TerrId | nvarchar | 10 | |||
Phone1 | nvarchar | 15 | |||
Phone2 | nvarchar | 15 | |||
Phone3 | nvarchar | 15 | |||
nvarchar | 255 | ||||
Internet | nvarchar | 255 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | |||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | |||
Rep1CommRate | pDecimal | 13 | |||
Rep2CommRate | pDecimal | 13 | |||
BillingType | nvarchar | 10 | |||
BillableYN | bit | 1 | |||
CustomerPoNumber | nvarchar | 25 | |||
PODate | datetime | 8 | |||
OriginalWorkOrder | pTransID | 8 | |||
BillByWorkOrder | bit | 1 | |||
FixedPrice | bit | 1 | |||
BillingFormat | nvarchar | 255 | |||
ProjectID | nvarchar | 10 | |||
PhaseID | nvarchar | 10 | |||
TaskID | nvarchar | 10 | |||
CF | xml | -1 | |||
BillVia | tinyint | 3 | 0 | 0 = SD, 1 = PC |
tblSvHistoryWorkOrderActivity -- SV Work Order Activity History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
ActivityType | tinyint | 1 | Work Order Activity Type | 0 = Request Received, 1 = Scheduled, 2 = Dispatched, 3 = Arrived / Started, 4 = Completed, 5 = Billed, 6 = Unbilled, 7 = Posted, 8 = Canceled, 9 = Reopened | |
ActivityDateTime | datetime | 8 | |||
TechID | pEmpID | 11 | |||
Duration | bigint | 8 | |||
EntryDate | datetime | 8 | |||
EnteredBy | pUserID | 20 | |||
Notes | nvarchar | max | |||
StatusDescription | pDescription | 255 | |||
CF | xml | -1 |
tblSvHistoryWorkOrderDispatch -- SV Work Order Dispatch History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
DispatchNo | int | 4 | |||
Description | pDescription | 255 | |||
EquipmentID | bigint | 8 | |||
EquipmentDescription | pDescription | 255 | |||
BillingType | nvarchar | 10 | |||
BillableYN | bit | 1 | |||
BillToID | pCustID | 10 | |||
RequestedDate | datetime | 8 | |||
RequestedAMPM | tinyint | 1 | Requested AM / PM | 0 = None, 1 = AM, 2 = PM | |
RequestedTechID | pEmpID | 11 | |||
CancelledYN | bit | 1 | |||
EstTravel | bigint | 8 | |||
SchedApproved | bit | 1 | |||
EntryDate | datetime | 8 | |||
Counter | int | 4 | |||
LocID | pLocID | 10 | |||
SourceId | uniqueidentifier | 16 | |||
PostRun | pPostRun | 14 | |||
StatusID | tinyint | 1 | |||
StatusDescription | pDescription | 255 | |||
CF | xml | -1 |
tblSvHistoryWorkOrderDispatchWorkToDo -- SV Work Order Dispatch Work To Do History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
WorkToDoID | nvarchar | 10 | |||
GroupID | nvarchar | 10 | |||
Description | pDescription | 255 | |||
EstimatedTime | bigint | 8 | |||
SkillLevel | tinyint | 1 | |||
CF | xml | -1 |
tblSvHistoryWorkOrderReferral -- SV Work Order Referral History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
CustID | pCustID | 10 | |||
CompanyName | nvarchar | 30 | |||
ContactName | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
nvarchar | 255 | ||||
Internet | nvarchar | 255 | |||
Notes | nvarchar | max | |||
CF | xml | -1 |
tblSvHistoryWorkOrderTrans -- SV Work Order Transaction History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
TransType | tinyint | 1 | Transaction Type | 0 = Labor, 1 = Part, 2 = Freight, 3 = Misc | |
ResourceID | nvarchar | 24 | |||
LaborCode | nvarchar | 10 | |||
Description | pDescription | 255 | |||
LocID | pLocID | 10 | |||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
FiscalYear | smallint | 2 | |||
FiscalPeriod | smallint | 2 | |||
AdditionalDescription | nvarchar | max | |||
QtyEstimated | pDecimal | 13 | |||
QtyUsed | pDecimal | 13 | |||
Unit | nvarchar | 5 | |||
UnitCost | pDecimal | 13 | |||
UnitPrice | pDecimal | 13 | |||
CostExt | pDecimal | 13 | |||
PriceExt | pDecimal | 13 | |||
TaxClass | tinyint | 1 | |||
GLAcctCredit | pGlAcct | 40 | |||
GLAcctDebit | pGlAcct | 40 | |||
GLAcctSales | pGlAcct | 40 | |||
HistSeqNum | int | 4 | |||
QtySeqNum_Cmtd | int | 4 | |||
QtySeqNum | int | 4 | |||
LinkSeqNum | int | 4 | |||
EntryNum | int | 4 | |||
CF | xml | -1 |
tblSvHistoryWorkOrderTransExt -- SV Extended Work Order Transaction History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
TransID | bigint | 8 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
QtyEstimated | pDecimal | 13 | |||
QtyUsed | pDecimal | 13 | |||
UnitCost | pDecimal | 13 | |||
HistSeqNum | int | 4 | |||
QtySeqNum_Cmtd | int | 4 | |||
QtySeqNum_Ext | int | 4 | |||
QtySeqNum | int | 4 | |||
Cmnt | nvarchar | 35 |
tblSvHistoryWorkOrderTransSer -- SV Work Order Serial Number Transaction History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
TransID | bigint | 8 | |||
SerNum | pSerNum | 35 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
UnitCost | pDecimal | 13 | |||
UnitCostACV | pDecimal | 13 | |||
UnitPrice | pDecimal | 13 | |||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 |
tblSvInvoiceDetail -- SV Invoice Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
EntryNum | int | 4 | |||
LineSeq | int | 4 | |||
ResourceID | nvarchar | 24 | |||
LocID | pLocID | 10 | |||
Description | pDescription | 255 | |||
AdditionalDescription | nvarchar | max | |||
TaxClass | tinyint | 1 | |||
QtyEstimated | pDecimal | 13 | 0 | ||
QtyUsed | pDecimal | 13 | 0 | ||
Unit | nvarchar | 5 | |||
UnitCostFgn | pDecimal | 13 | 0 | ||
UnitPriceFgn | pDecimal | 13 | 0 | ||
CostExtFgn | pDecimal | 13 | 0 | ||
PriceExtFgn | pDecimal | 13 | 0 | ||
UnitCommBasisFgn | pDecimal | 13 | |||
UnitCost | pDecimal | 13 | 0 | ||
UnitPrice | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
PriceExt | pDecimal | 13 | 0 | ||
UnitCommBasis | pDecimal | 13 | |||
GLAcctCredit | pGlAcct | 40 | |||
GLAcctDebit | pGlAcct | 40 | |||
GLAcctSales | pGlAcct | 40 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
WorkOrderTransID | bigint | 8 | |||
WorkOrderTransType | tinyint | 1 | Work Order Transaction Type | 0 = Labor, 1 = Part, 2 = Freight, 3 = Misc | |
DispatchID | bigint | 8 | |||
CatID | nvarchar | 2 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvInvoiceDispatch -- SV Invoice Dispatch table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
DispatchID | bigint | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvInvoiceHeader -- SV Invoice Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
TransType | smallint | 2 | |||
VoidYN | bit | 1 | 0 | ||
BatchID | pBatchID | 10 | |||
CustID | pCustID | 10 | |||
BillToID | pCustID | 10 | |||
TermsCode | pTermsCode | 6 | |||
DistCode | pDistCode | 6 | |||
TaxableYN | bit | 1 | -1 | ||
InvoiceNumber | pInvoiceNum | 15 | |||
InvoiceDate | datetime | 8 | |||
CustomerPoNumber | nvarchar | 25 | |||
PODate | datetime | 8 | |||
WorkOrderNo | pTransID | 8 | |||
OrderDate | datetime | 8 | |||
CompletedDate | datetime | 8 | |||
DiscDueDate | datetime | 8 | |||
NetDueDate | datetime | 8 | |||
FiscalYear | smallint | 2 | |||
FiscalPeriod | smallint | 2 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
TaxGrpID | pTaxLoc | 10 | |||
TaxLocAdj | pTaxLoc | 10 | |||
TaxClassAdj | tinyint | 1 | |||
TaxSubtotalFgn | pDecimal | 13 | 0 | ||
NonTaxSubtotalFgn | pDecimal | 13 | 0 | ||
SalesTaxFgn | pDecimal | 13 | 0 | ||
TotCostFgn | pDecimal | 13 | 0 | ||
TotPmtAmtFgn | pDecimal | 13 | 0 | ||
DiscAmtFgn | pDecimal | 13 | 0 | ||
TaxAmtAdjFgn | pDecimal | 13 | 0 | ||
TaxSubtotal | pDecimal | 13 | 0 | ||
NonTaxSubtotal | pDecimal | 13 | 0 | ||
SalesTax | pDecimal | 13 | 0 | ||
TotCost | pDecimal | 13 | 0 | ||
TotPmtAmt | pDecimal | 13 | 0 | ||
DiscAmt | pDecimal | 13 | 0 | ||
TaxAmtAdj | pDecimal | 13 | 0 | ||
BillingFormat | nvarchar | 255 | |||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
HoldYN | bit | 1 | 0 | ||
SourceId | uniqueidentifier | 16 | |||
WorkOrderID | bigint | 8 | |||
PrintStatus | tinyint | 1 | 0 | Print Status | 0 = Unprinted, 1 = Online, 2 = Batch, 3 = Skip |
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*TaxGrpId2 | pTaxLoc |
tblSvInvoiceTax -- SV Invoice Tax table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | 0 | ||
Level | tinyint | 1 | -1 | ||
TaxAmt | pDecimal | 13 | 0 | ||
TaxAmtFgn | pDecimal | 13 | 0 | ||
Taxable | pDecimal | 13 | 0 | ||
TaxableFgn | pDecimal | 13 | 0 | ||
NonTaxable | pDecimal | 13 | 0 | ||
NonTaxableFgn | pDecimal | 13 | 0 | ||
LiabilityAcct | pGlAcct | 40 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
ExpenseAccount | pGlAcct |
tblSvLaborCode -- SV Labor Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
LaborCode | nvarchar | 10 | |||
Description | nvarchar | 35 | |||
AdditionalDescription | nvarchar | max | |||
Unit | nvarchar | 5 | |||
BillingRate | pDecimal | 13 | 0 | ||
UnitCost | pDecimal | 13 | 0 | ||
GLAcctSales | pGlAcct | 40 | |||
GLAcctCost | pGlAcct | 40 | |||
GLAcctPayroll | pGlAcct | 40 | |||
TaxClass | tinyint | 1 | |||
CalendarColor | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvPaymentLocal -- SV Local Payment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
PmtDate | datetime | 8 | |||
PmtType | tinyint | 1 | |||
PmtMethodID | nvarchar | 10 | |||
CcNum | nvarchar | 255 | |||
CcHolder | nvarchar | 30 | |||
CcExpire | datetime | 8 | |||
CcAuth | nvarchar | 10 | |||
CcRef | nvarchar | 255 | |||
CheckNum | nvarchar | 10 | |||
BankName | nvarchar | 30 | |||
BankRoutingCode | nvarchar | 9 | |||
BankAcctNum | nvarchar | 255 | |||
Amount | decimal | 28,10 | |||
AmountBase | decimal | 28,10 | |||
CurrencyID | nvarchar | 6 | |||
VoidDate | datetime | 8 | |||
TechID | bigint | 8 | |||
HostID | nvarchar | 20 | |||
EntryDate | datetime | 8 | |||
Settled | bit | 1 | |||
Response | nvarchar | max | information from payment provider | ||
Notes | nvarchar | max | |||
iCap | varbinary | max | |||
InvoiceNumber | nvarchar | 15 | |||
SynchID | bigint | 8 | |||
Synched | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtPmtActivityID | bigint | 8 |
tblSvServiceContractDetail -- SV Service Contract Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
ContractID | bigint | 8 | |||
EquipmentID | bigint | 8 | |||
CoverageType | tinyint | 1 | 0 | Coverage Type | 0 = None, 1 = Labor / Parts, 2 = Labor, 3 = Parts |
ContractAmount | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvServiceContractHeader -- SV Service Contract Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
ContractNo | nvarchar | 8 | |||
CustID | pCustID | 10 | |||
Description | pDescription | 255 | |||
StartDate | datetime | 8 | |||
EndDate | datetime | 8 | |||
OriginalContractDate | datetime | 8 | |||
Notes | nvarchar | max | |||
RecurID | nvarchar | 8 | |||
BillingType | tinyint | 1 | 2 | Billing Type | 0 = As Needed, 1 = Days, 2 = Monthly, 3 = Quarterly, 4 = Yearly |
NextBillingDate | datetime | 8 | |||
BillingAmount | pDecimal | 13 | 0 | ||
BillingInterval | tinyint | 1 | 0 | ||
LastBillingDate | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvSkill -- SV Skill table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SkillLevel | tinyint | 1 | |||
Description | pDescription | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvSynchTrans -- SV Synchronization Transaction table (local to tablet only)
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SynchID | bigint | 8 | |||
TransType | smallint | 2 | 0 = Dispatch, 1 = Transaction, 2 = Payment, 3 = DispatchWorkToDo, 4 = Attachment | ||
TransID | bigint | 8 | |||
ts | timestamp | 8 |
tblSvTechnician -- SV Technician table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TechID | pEmpID | 11 | |||
ScheduleID | nvarchar | 10 | |||
LocID | pLocID | 10 | |||
CrewYN | bit | 1 | 0 | ||
Description | pDescription | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ID | bigint | 8 | |||
Password | nvarchar | max |
tblSvTechnicianLaborCode -- SV Technician Labor Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
TechID | pEmpID | 11 | |||
LaborCode | nvarchar | 10 | |||
SkillLevel | tinyint | 1 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvTechnicianRelation -- SV Technician Relation table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
TechID | pEmpID | 11 | |||
RelationID | pEmpID | 11 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvTechnicianPermission -- SV Technician Permission table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
TechID | bigint | 8 | |||
FeatureID | bigint | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrder -- SV Work Order table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
WorkOrderNo | pTransID | 8 | |||
OrderDate | datetime | 8 | |||
CustID | pCustID | 10 | |||
SiteID | pLocID | 10 | |||
Attention | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
TerrId | nvarchar | 10 | |||
Phone1 | nvarchar | 15 | |||
Phone2 | nvarchar | 15 | |||
Phone3 | nvarchar | 15 | |||
nvarchar | 255 | ||||
Internet | nvarchar | 255 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
BillingType | nvarchar | 10 | |||
CustomerPoNumber | nvarchar | 25 | |||
PODate | datetime | 8 | |||
OriginalWorkOrder | pTransID | 8 | |||
BillByWorkOrder | bit | 1 | 0 | ||
FixedPrice | bit | 1 | 0 | ||
BillingFormat | nvarchar | 255 | |||
ProjectDetailID | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
BillVia | tinyint | 1 | 0 | 0 = SD, 1 = PC |
tblSvWorkOrderActivity -- SV Work Order Activity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
ActivityType | tinyint | 1 | Work Order Activity Type | 0 = Request Received, 1 = Scheduled, 2 = Dispatched, 3 = Arrived / Started, 4 = Completed, 5 = Billed, 6 = Unbilled, 7 = Posted, 8 = Canceled, 9 = Reopened, 10 = Payment Received, 11 = Hold, 12 = Release | |
ActivityDateTime | datetime | 8 | |||
TechID | pEmpID | 11 | |||
Duration | bigint | 8 | 0 | ||
EntryDate | datetime | 8 | |||
EnteredBy | pUserID | 20 | |||
Notes | nvarchar | max | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderDispatch -- SV Work Order Dispatch table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
DispatchNo | int | 4 | |||
Description | pDescription | 255 | |||
Status | tinyint | 1 | Dispatch Status | 0 = Open, 1 = Completed, 2 = Billed, 3 = Posted | |
EquipmentID | bigint | 8 | |||
EquipmentDescription | pDescription | 255 | |||
BillingType | nvarchar | 10 | |||
BillToID | pCustID | 10 | |||
RequestedDate | datetime | 8 | |||
RequestedAMPM | tinyint | 1 | 0 | Requested AM / PM | 0 = None, 1 = AM, 2 = PM |
RequestedTechID | pEmpID | 11 | |||
CancelledYN | bit | 1 | 0 | ||
HoldYN | bit | 1 | 0 | ||
EstTravel | bigint | 8 | 0 | ||
SchedApproved | bit | 1 | 0 | ||
EntryDate | datetime | 8 | |||
Counter | int | 4 | |||
LocID | pLocID | 10 | |||
SourceId | uniqueidentifier | 16 | |||
PostRun | pPostRun | 14 | |||
StatusID | tinyint | 1 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderDispatchLocal -- SV Local Work Order Dispatch table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
Started | datetime | 8 | |||
Completed | datetime | 8 | |||
Cancelled | datetime | 8 | |||
Held | datetime | 8 | |||
TechID | bigint | 8 | |||
HostID | nvarchar | 20 | |||
SynchID | bigint | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderDispatchWorkToDo -- SV Work Order Dispatch Work To Do table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
WorkToDoID | nvarchar | 10 | |||
GroupID | nvarchar | 10 | |||
Description | pDescription | 255 | |||
EstimatedTime | bigint | 8 | |||
SkillLevel | tinyint | 1 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderDispatchWorkToDoLocal -- SV Local Work Order Dispatch Work To Do table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
WorkToDoID | nvarchar | 10 | |||
Description | nvarchar | 255 | |||
EstimatedTime | bigint | 8 | 0 | ||
SkillLevel | tinyint | 1 | |||
TechID | bigint | 8 | |||
HostID | nvarchar | 20 | |||
SynchID | bigint | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderReferral -- SV Work Order Referral table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
CustID | pCustID | 10 | |||
CompanyName | nvarchar | 30 | |||
ContactName | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
nvarchar | 255 | ||||
Internet | nvarchar | 255 | |||
Notes | nvarchar | max | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderTrans -- SV Work Order Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
TransType | tinyint | 1 | Transaction Type | 0 = Labor, 1 = Part, 2 = Freight, 3 = Misc | |
ResourceID | nvarchar | 24 | |||
LaborCode | nvarchar | 10 | |||
Description | pDescription | 255 | |||
LocID | pLocID | 10 | |||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
FiscalYear | smallint | 2 | |||
FiscalPeriod | smallint | 2 | |||
AdditionalDescription | nvarchar | max | |||
QtyEstimated | pDecimal | 13 | 0 | ||
QtyUsed | pDecimal | 13 | 0 | ||
Unit | nvarchar | 5 | |||
UnitCost | pDecimal | 13 | 0 | ||
UnitPrice | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
PriceExt | pDecimal | 13 | 0 | ||
TaxClass | tinyint | 1 | |||
GLAcctCredit | pGlAcct | 40 | |||
GLAcctDebit | pGlAcct | 40 | |||
GLAcctSales | pGlAcct | 40 | |||
HistSeqNum | int | 4 | |||
QtySeqNum_Cmtd | int | 4 | |||
QtySeqNum | int | 4 | |||
LinkSeqNum | int | 4 | |||
EntryNum | int | 4 | |||
Status | tinyint | 1 | 0 | Status | 0 = New, 1 = Posted |
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderTransExt -- SV Extended Work Order Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
TransID | bigint | 8 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
QtyEstimated | pDecimal | 13 | 0 | ||
QtyUsed | pDecimal | 13 | 0 | ||
UnitCost | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
QtySeqNum_Cmtd | int | 4 | |||
QtySeqNum_Ext | int | 4 | |||
QtySeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderTransLocal -- SV Local Work Order Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
DispatchID | bigint | 8 | |||
WorkOrderID | bigint | 8 | |||
TransType | tinyint | 1 | Transaction Type | 0 = Labor, 1 = Part, 2 = Freight, 3 = Misc | |
ResourceID | nvarchar | 24 | |||
LaborCode | nvarchar | 6 | |||
Description | nvarchar | 255 | |||
LocID | nvarchar | 10 | |||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
AdditionalDescription | nvarchar | max | |||
Qty | decimal | 28,10 | 0 | ||
Unit | nvarchar | 5 | |||
Price | decimal | 28,10 | 0 | ||
LotNum | nvarchar | 16 | |||
SerNum | nvarchar | 35 | |||
TaxClass | tinyint | 1 | |||
TaxAmount | decimal | 28,10 | 0 | ||
SynchID | bigint | 8 | |||
TechID | bigint | 8 | |||
HostID | nvarchar | 20 | |||
Synched | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkOrderTransSer -- SV Work Order Serial Number Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
TransID | bigint | 8 | |||
SerNum | pSerNum | 35 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
UnitCost | pDecimal | 13 | 0 | ||
UnitCostACV | pDecimal | 13 | 0 | ||
UnitPrice | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkToDo -- SV Work To Do table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
WorkToDoID | nvarchar | 10 | |||
Description | pDescription | 255 | |||
LaborCode | nvarchar | 10 | |||
EstimatedTime | bigint | 8 | |||
RequiredSkillLevel | tinyint | 1 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSvWorkToDoRelation -- SV Work To Do Relationship table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | int | 4 | |||
WorkToDoID | nvarchar | 10 | |||
RelationID | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |